APPS.GMPPSRP dependencies on PS_MATL_DTL

Line 146: FROM ps_matl_dtl pmd1

142: FROM ps_matl_hdr pmh
143: WHERE pmh.matl_rep_id = G_matl_rep_id
144: AND
145: ((pmh.inventory_item_id NOT IN (SELECT pmd1.inventory_item_id
146: FROM ps_matl_dtl pmd1
147: WHERE pmd1.matl_rep_id = G_matl_rep_id))
148: OR
149: (pmh.organization_id NOT IN (SELECT organization_id
150: FROM ps_matl_dtl pmd2

Line 150: FROM ps_matl_dtl pmd2

146: FROM ps_matl_dtl pmd1
147: WHERE pmd1.matl_rep_id = G_matl_rep_id))
148: OR
149: (pmh.organization_id NOT IN (SELECT organization_id
150: FROM ps_matl_dtl pmd2
151: WHERE pmd2.inventory_item_id = pmh.inventory_item_id
152: AND pmd2.matl_rep_id = G_matl_rep_id)));
153: END IF;
154:

Line 432: | to populate ps_matl_dtl table |

428: | |
429: | FUNCTION NAME ps_bucket_details |
430: | |
431: | DESCRIPTION Function to make a call to the stored procedure |
432: | to populate ps_matl_dtl table |
433: | |
434: | MODIFICATION HISTORY |
435: | 07/14/01 Praveen Reddy ----- created |
436: | |

Line 676: ' FROM ps_matl_dtl pmd ' ||

672: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
673: ' gmppsrp.category(pmh.category_id) category, ' ||
674: ' CURSOR( ' ||
675: ' SELECT pmd.* ' ||
676: ' FROM ps_matl_dtl pmd ' ||
677: ' WHERE pmd.inventory_item_id = pmh.inventory_item_id ' ||
678: ' AND pmd.organization_id = pmh.organization_id ' ||
679: ' AND pmd.matl_rep_id = pmh.matl_rep_id ' ||
680: ' ORDER BY pmd.inventory_item_id, pmd.organization_id, pmd.perd_end_date ' ||