Query Standard Comments used on a Purchase Order?
Hello Everyone,
I am attempting to query PO's where a specific standard comment was used. We are on PS 9.1
I was looking at STD_COMM_TBL_PO (looking at the STD_COMMENT_TYPE and STD_COMMENT_ID) , PO_COMMENTS, PO_HDR, etc. but there doesn't seem to be anything to tie the standard comment used to the Purchase Order. Maybe if the Standard Comment ID as in the Source_ID Field?
I need to know on what PO's people used a specific standard comments... any ideas?
Thanks,
WMJ