DBA Data[Home] [Help]

APPS.JAI_GENERAL_PKG dependencies on QP_LIST_LINES

Line 689: qp_list_lines b,

685: b.operand list_price,
686: c.product_uom_code list_price_uom_code
687: FROM
688: JAI_CMN_CUS_ADDRESSES a,
689: qp_list_lines b,
690: qp_pricing_attributes c
691: WHERE
692: a.customer_id = p_party_id AND
693: a.address_id = p_address_id AND

Line 717: qp_list_lines b,

713: b.operand list_price,
714: c.product_uom_code list_price_uom_code
715: FROM
716: JAI_CMN_CUS_ADDRESSES a,
717: qp_list_lines b,
718: qp_pricing_attributes c
719: WHERE
720: a.customer_id = p_party_id AND
721: a.address_id = p_address_id AND

Line 741: qp_list_lines b,

737: b.operand list_price,
738: c.product_uom_code list_price_uom_code
739: FROM
740: JAI_CMN_CUS_ADDRESSES a,
741: qp_list_lines b,
742: qp_pricing_attributes c
743: WHERE
744: a.customer_id = p_party_id AND
745: a.address_id = p_address_id AND

Line 766: qp_list_lines b,

762: b.operand list_price,
763: c.product_uom_code list_price_uom_code ,
764: qlhb.currency_code /* Added for bug#16288090 */
765: FROM
766: qp_list_lines b,
767: qp_pricing_attributes c,
768: qp_list_headers_b qlhb /* Added for bug#16288090 */
769: WHERE
770: c.list_line_id = b.list_line_id AND

Line 800: qp_list_lines b,

796: b.operand list_price,
797: c.product_uom_code list_price_uom_code ,
798: qlhb.currency_code /* Added for bug#16288090 */
799: FROM
800: qp_list_lines b,
801: qp_pricing_attributes c,
802: qp_list_headers_b qlhb /* Added for bug#16288090 */
803: WHERE
804: c.list_line_id = b.list_line_id AND

Line 833: qp_list_lines b,

829: b.operand list_price,
830: c.product_uom_code list_price_uom_code ,
831: qlhb.currency_code /* Added for bug#16288090 */
832: FROM
833: qp_list_lines b,
834: qp_pricing_attributes c,
835: qp_list_headers_b qlhb /* Added for bug#16288090 */
836: WHERE
837: c.list_line_id = b.list_line_id AND

Line 875: qp_list_lines b,

871: c.product_uom_code list_price_uom_code,
872: qlhb.currency_code /* Added for bug#16288090 */
873: FROM
874: JAI_CMN_VENDOR_SITES a,
875: qp_list_lines b,
876: qp_pricing_attributes c,
877: qp_list_headers_b qlhb /* Added for bug#16288090 */
878: WHERE
879: a.vendor_id = p_vendor_id AND

Line 910: qp_list_lines b,

906: c.product_uom_code list_price_uom_code,
907: qlhb.currency_code /* Added for bug#16288090 */
908: FROM
909: JAI_CMN_VENDOR_SITES a,
910: qp_list_lines b,
911: qp_pricing_attributes c,
912: qp_list_headers_b qlhb /* Added for bug#16288090 */
913: WHERE
914: a.vendor_id = p_vendor_id AND

Line 940: qp_list_lines b,

936: c.product_uom_code list_price_uom_code,
937: qlhb.currency_code /* Added for bug#16288090 */
938: FROM
939: JAI_CMN_VENDOR_SITES a,
940: qp_list_lines b,
941: qp_pricing_attributes c,
942: qp_list_headers_b qlhb /* Added for bug#16288090 */
943: WHERE
944: a.vendor_id = p_vendor_id AND

Line 1001: , qp_list_lines b

997: , c.product_uom_code list_price_uom_code ,
998: qlhb.currency_code /* Added for bug#16288090 */
999: FROM
1000: jai_cmn_cus_addresses a
1001: , qp_list_lines b
1002: , qp_pricing_attributes c,
1003: qp_list_headers_b qlhb /* Added for bug#16288090 */
1004: WHERE a.customer_id = pn_party_id
1005: AND a.address_id = pn_address_id

Line 1038: , qp_list_lines b

1034: , c.product_uom_code list_price_uom_code ,
1035: qlhb.currency_code /* Added for bug#16288090 */
1036: FROM
1037: jai_cmn_cus_addresses a
1038: , qp_list_lines b
1039: , qp_pricing_attributes c,
1040: qp_list_headers_b qlhb /* Added for bug#16288090 */
1041: WHERE a.customer_id = pn_party_id
1042: AND a.address_id = pn_address_id

Line 1074: , qp_list_lines b

1070: , c.product_uom_code list_price_uom_code ,
1071: qlhb.currency_code /* Added for bug#16288090 */
1072: FROM
1073: jai_cmn_cus_addresses a
1074: , qp_list_lines b
1075: , qp_pricing_attributes c,
1076: qp_list_headers_b qlhb /* Added for bug#16288090 */
1077: WHERE a.customer_id = pn_party_id
1078: AND a.address_id = pn_address_id

Line 1111: , qp_list_lines b

1107: , c.product_uom_code list_price_uom_code ,
1108: qlhb.currency_code /* Added for bug#16288090 */
1109: FROM
1110: jai_cmn_vendor_sites a
1111: , qp_list_lines b
1112: , qp_pricing_attributes c,
1113: qp_list_headers_b qlhb /* Added for bug#16288090 */
1114: WHERE a.vendor_id = pn_vendor_id
1115: AND a.vendor_site_id = pn_address_id

Line 1148: , qp_list_lines b

1144: , c.product_uom_code list_price_uom_code ,
1145: qlhb.currency_code /* Added for bug#16288090 */
1146: FROM
1147: jai_cmn_vendor_sites a
1148: , qp_list_lines b
1149: , qp_pricing_attributes c,
1150: qp_list_headers_b qlhb /* Added for bug#16288090 */
1151: WHERE a.vendor_id = pn_vendor_id
1152: AND a.vendor_site_id = pn_address_id

Line 1184: , qp_list_lines b

1180: , c.product_uom_code list_price_uom_code ,
1181: qlhb.currency_code /* Added for bug#16288090 */
1182: FROM
1183: jai_cmn_vendor_sites a
1184: , qp_list_lines b
1185: , qp_pricing_attributes c,
1186: qp_list_headers_b qlhb /* Added for bug#16288090 */
1187: WHERE a.vendor_id = pn_vendor_id
1188: AND a.vendor_site_id = pn_address_id