APPS.GMPMPACT dependencies on PS_UBKT_DTL

Line 181: FROM ps_ubkt_dtl pud1

177: FROM ps_matl_hdr pmh
178: WHERE pmh.matl_rep_id = G_matl_rep_id
179: AND
180: ((pmh.inventory_item_id NOT IN (SELECT pud1.inventory_item_id
181: FROM ps_ubkt_dtl pud1
182: WHERE pud1.matl_rep_id = G_matl_rep_id))
183: OR
184: (pmh.organization_id NOT IN (SELECT organization_id
185: FROM ps_ubkt_dtl pud2

Line 185: FROM ps_ubkt_dtl pud2

181: FROM ps_ubkt_dtl pud1
182: WHERE pud1.matl_rep_id = G_matl_rep_id))
183: OR
184: (pmh.organization_id NOT IN (SELECT organization_id
185: FROM ps_ubkt_dtl pud2
186: WHERE pud2.inventory_item_id = pmh.inventory_item_id
187: AND pud2.matl_rep_id = G_matl_rep_id)));
188: END IF;
189:

Line 461: FROM ps_ubkt_dtl

457: CURSOR Cur_check_dtl IS
458: SELECT 1
459: FROM FND_DUAL
460: WHERE EXISTS (SELECT matl_rep_id
461: FROM ps_ubkt_dtl
462: WHERE matl_rep_id = G_matl_rep_id) ;
463:
464: X_ret NUMBER;
465: X_i NUMBER := 0;

Line 1191: INSERT INTO ps_ubkt_dtl(matl_rep_id,

1187: X_pastdue := NULL;
1188: END IF;
1189: --Insert the record into the detail table.
1190:
1191: INSERT INTO ps_ubkt_dtl(matl_rep_id,
1192: -- item_id,
1193: inventory_item_id,
1194: -- planning_class,
1195: -- whse_code,

Line 1240: INSERT INTO ps_ubkt_dtl(matl_rep_id,

1236: X_pastdue := NULL;
1237: END IF;
1238:
1239:
1240: INSERT INTO ps_ubkt_dtl(matl_rep_id,
1241: -- item_id,
1242: inventory_item_id,
1243: -- planning_class,
1244: -- whse_code,

Line 1295: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to ps_ubkt_dtl'||sqlerrm);

1291:
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294: -- X_WHSE_LIST:=SQLERRM;
1295: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to ps_ubkt_dtl'||sqlerrm);
1296:
1297: /* b3668927 nsinghi : Closing cursors in exception block. */
1298: IF dbms_sql.is_open(X_doc) THEN
1299: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');

Line 1822: ' FROM ps_ubkt_dtl pud ' ||

1818: ' pud.critical_ind critical_ind, ' ||
1819: ' pud.cust_vend cust_vend, ' ||
1820: ' pud.inventory_item_id inventory_item_id, ' ||
1821: ' gmpmpact.organization_code (pud.organization_id) organization_code ' ||
1822: ' FROM ps_ubkt_dtl pud ' ||
1823: ' WHERE pud.inventory_item_id = pmh.inventory_item_id ' ||
1824: ' AND pud.organization_id = pmh.organization_id ' ||
1825: ' AND pud.matl_rep_id = pmh.matl_rep_id ' ||
1826: ' ORDER BY pud.inventory_item_id, pud.organization_id, pud.trans_date, pud.doc_type ' ||