DBA Data[Home] [Help]

APPS.GMPMRACT dependencies on OP_CUST_MST

Line 1031: FROM op_cust_mst cs, op_ordr_dtl dt

1027: #############################################################################*/
1028: PROCEDURE mr_cleanup_details IS
1029: CURSOR Cur_custno IS
1030: SELECT cs.cust_no cust_no
1031: FROM op_cust_mst cs, op_ordr_dtl dt
1032: WHERE dt.bol_id = G_doc_id
1033: AND dt.shipcust_id = cs.cust_id;
1034:
1035: --Bug#2131275 P.Raghu

Line 1078: FROM op_ordr_hdr op, op_cust_mst cs

1074: AND vn.vendor_id (+) = prh.vendor_id ;
1075:
1076: CURSOR Cur_cust_dtl IS
1077: SELECT op.orgn_code, op.order_no,cs.cust_no
1078: FROM op_ordr_hdr op, op_cust_mst cs
1079: WHERE op.order_id = G_doc_id
1080: AND op.shipcust_id = cs.cust_id;
1081:
1082: CURSOR Cur_order_dtl IS